﻿CREATE TABLE [flcrTM].[DEVICE_CONFIG_PROPERTY] (
    [TM_DEVICE_CONFIG_PROPERTY_ID] INT          IDENTITY (1, 1) NOT NULL,
    [TIME_KEY]                     INT          NOT NULL,
    [DEVICE_CONFIG_PROPERTY_ID]    INT          NOT NULL,
    [AUDIT_USER]                   VARCHAR (50) NOT NULL,
    [AUDIT_DTTM]                   DATETIME     NOT NULL,
    [AUDIT_DTTM_TZ]                INT          NOT NULL,
    [AUDIT_MOD_USER]               VARCHAR (50) NOT NULL,
    [AUDIT_MOD_DTTM]               DATETIME     NOT NULL,
    [AUDIT_MOD_DTTM_TZ]            INT          NOT NULL,
    [BUILTIN]                      BIT          NOT NULL,
    [ACTIVE_FLG]                   BIT          NOT NULL,
    [SORT_ORDER]                   INT          NOT NULL,
    [DEVICE_ID]                    INT          NOT NULL,
    [PVALUE_DEVICE_PROP_TYPE]      INT          NOT NULL,
    [PNAME_DEVICE_PROP_TYPE]       INT          NOT NULL,
    [PARENT_ID]                    INT          NULL,
    [AUTOCOLLECT_DEFAULT_FLG]      BIT          NOT NULL
);

